package com.gljx.web.service;

import com.gljx.web.Entity.SubjectThreeResult;
import com.gljx.web.Entity.User;

import java.util.List;
import java.util.Map;

public interface SubjectThreeResultService {
	Map<String, Object> selectPageCount(String psql);

    Map<String, Object> selectPage(int pindex, String psql, int psize);
    
    /**
   	 * 查找最大编码
   	 * @return
   	 */
   	String selectFnumber(String companyId);
   	
	/**
   	 * 增加科目三考试登记信息
   	 * @param subjectThreeResult
   	 * @return
   	 */
   	int addSubjectThreeResult(User user, SubjectThreeResult subjectThreeResult, String [] stuid, String [] stufseq, String [] stucfzkzmbh, String [] stufnumber, String [] stuname,
							  String [] stucfidcardno, String [] stucfsex, String [] stucfsjhm, String [] stucflxdh, String [] stucfslzjcxdh, String [] stucfclazzName,
							  String [] stucfamount, String [] stucfreceived, String [] stucfarrearage, String [] stucffavorable, String [] stucfvip, String [] stucflocal,
							  String [] stucfexamresult, String [] stucfremark);
   	
   	/**
   	 * 根据fid删除
   	 * @param fid
   	 * @return
   	 */
   	int deleteSubjectThreeResult(String fid);
   	/**
	 * 根据fid查找科目二考试结果登记信息
	 * @param fid
	 * @return
	 */
	SubjectThreeResult selectSubjectThreeResultByFid(String fid);

	/**
	 * 提交单据
	 * @param subjectThreeResult
	 * @return
	 */
	int submitSubjectThreeResult(SubjectThreeResult subjectThreeResult);
	/**
	 * 审核
	 * @param subjectThreeResult
	 */
	int updateSubjectThreeResult(SubjectThreeResult subjectThreeResult);
	/**
	 * 修改
	 * @param subjectThreeResult
	 * @param stuid
	 * @param stufseq
	 * @param stucfzkzmbh
	 * @param stufnumber
	 * @param stuname
	 * @param stucfidcardno
	 * @param stucfsex
	 * @param stucfsjhm
	 * @param stucflxdh
	 * @param stucfslzjcxdh
	 * @param stucfclazzName
	 * @param stucfamount
	 * @param stucfreceived
	 * @param stucfarrearage
	 * @param stucffavorable
	 * @param stucfvip
	 * @param stucflocal
	 * @param stucfexamresult
	 * @param stucfremark
	 */
	int updateSubjectThreeResult(User user,SubjectThreeResult subjectThreeResult,String [] stuid,String [] stufseq,String [] stucfzkzmbh,String [] stufnumber,String [] stuname,
   			String [] stucfidcardno,String [] stucfsex,String [] stucfsjhm,String [] stucflxdh,String [] stucfslzjcxdh,String [] stucfclazzName,
   			String [] stucfamount,String [] stucfreceived,String [] stucfarrearage,String [] stucffavorable,String [] stucfvip,String [] stucflocal,
   			String [] stucfexamresult,String [] stucfremark);

	List<SubjectThreeResult> selectSubjectThreeResult(String companyId, String fnumber, String fdescription, String beginTime, String endTime);
}
